MLS Data and Map

Obtained .csv data from ‘https://github.com/gavinr/usa-soccer’ and removed unnecessary data. Added total championships for each team, data from ‘https://www.goal.com/en-us/news/mls-cup-all-winners-list/blt15fd45904a53e495’.

Create a map of mls teams and number of championships won

MLS Team and Number of Championships Data through 2022 season

Determine the top 2 clubs based on number of championships and create a subset table

##                      team  longitude latitude championships
## 13              LA Galaxy -118.26100 33.86400             5
## 8             D.C. United  -77.01287 38.86841             4
## 7           Columbus Crew  -83.01709 39.96846             2
## 11      Houston Dynamo FC  -95.35240 29.75220             2
## 24   San Jose Earthquakes -121.92500 37.35139             2
## 25    Seattle Sounders FC -122.33160 47.59520             2
## 26   Sporting Kansas City  -94.82100 39.12140             2
## 1       Atlanta United FC  -84.40000 33.75556             1
## 5         Chicago Fire FC  -87.61670 41.86230             1
## 6         Colorado Rapids -104.89194 39.80556             1
## 14         Los Angeles FC -118.28500 34.01300             1
## 18       New York City FC  -73.92639 40.82917             1
## 22       Portland Timbers -122.69167 45.52139             1
## 23         Real Salt Lake -111.89340 40.58290             1
## 28             Toronto FC  -79.41861 43.63278             1
## 2               Austin FC  -97.71984 30.38821             0
## 3             CF Montreal  -73.55250 45.56306             0
## 4            Charlotte FC  -80.85278 35.22583             0
## 9           FC Cincinnati  -84.52222 39.11139             0
## 10              FC Dallas  -96.83528 33.15444             0
## 12         Inter Miami CF  -80.16111 26.19306             0
## 15    Minnesota United FC  -93.16500 44.95278             0
## 16           Nashville SC  -86.76556 36.13028             0
## 17 New England Revolution  -71.26400 42.09100             0
## 19     New York Red Bulls  -74.15028 40.73667             0
## 20        Orlando City SC  -81.38930 28.54110             0
## 21     Philadelphia Union  -75.37889 39.83222             0
## 27      St. Louis City SC  -90.21092 38.63103             0
## 29 Vancouver Whitecaps FC -123.11194 49.27667             0

It was determined that LA Galaxy and DC United have the most championships with 6 and 5, respectfully. Its to be noted that although they have significantly more titles, the next closest teams with 2, they have were in the MLS since it was founded in 1996

Obtained average attendance records for the 2021 season from ‘https://www.worldfootball.net/attendance/usa-major-league-soccer-2021/3/’, placed the data in a .csv and imported it.

##                   ï..Team Average.Attendance Stadium.Capacity
## 17       New York City FC             10,932           30,321
## 26             Toronto FC             10,442           28,351
## 18     New York Red Bulls             12,558           25,000
## 4            Chicago Fire             13,160           24,995
## 13     Los Angeles Galaxy             14,580           27,000
## 24       Seattle Sounders             20,443           37,722
## 3             CF Montreal             10,831           19,619
## 27    Vancouver Whitecaps             12,315           22,120
## 19           Orlando City             14,489           25,500
## 21       Portland Timbers             15,120           25,218
## 10         Houston Dynamo             13,517           22,039
## 15           Nashville SC             18,326           30,000
## 8           FC Cincinnati             16,644           26,000
## 7             D.C. United             12,919           20,000
## 5         Colorado Rapids             12,291           18,061
## 16 New England Revolution             13,579           20,000
## 1       Atlanta United FC             29,899           42,500
## 20     Philadelphia Union             13,069           18,500
## 9               FC Dallas             14,034           19,096
## 23   San Jose Earthquakes             13,317           18,000
## 14    Minnesota United FC             14,533           19,400
## 2               Austin FC             16,019           20,738
## 22         Real Salt Lake             15,643           20,213
## 6           Columbus Crew             16,315           20,371
## 25   Sporting Kansas City             14,756           18,467
## 11         Inter Miami CF             15,828           18,000
## 12         Los Angeles FC             19,439           22,000
##    Attendance.Percent
## 17               0.36
## 26               0.37
## 18               0.50
## 4                0.53
## 13               0.54
## 24               0.54
## 3                0.55
## 27               0.56
## 19               0.57
## 21               0.60
## 10               0.61
## 15               0.61
## 8                0.64
## 7                0.65
## 5                0.68
## 16               0.68
## 1                0.70
## 20               0.71
## 9                0.73
## 23               0.74
## 14               0.75
## 2                0.77
## 22               0.77
## 6                0.80
## 25               0.80
## 11               0.88
## 12               0.88

New York City FC has the lowest attendance average, only filling 36 percent of their stadium. Los Angeles FC on average fills 88 percent of their stadium.

LA, DC, and NYC Demographics

Pull 2021 acs census data for Washington DC and Los Angeles to analyze demographics of the two most successful teams in mls history.

## Getting data from the 2017-2021 5-year ACS
## Getting data from the 2017-2021 5-year ACS
## Getting data from the 2017-2021 5-year ACS
## Getting data from the 2017-2021 5-year ACS

Pull 2021 acs census data for New York to analyze demographics in comparison to attendance averages and mhhi.

## Getting data from the 2017-2021 5-year ACS
## Getting data from the 2017-2021 5-year ACS

Plots

Plot demographics to compare median income and percent Hispanic

N 10 km 0 25 50 75 100 ACS Estimate LA Hispanic Population Data from 2021 1-year ACS, US Census Bureau
N 10 km 0 50000 100000 150000 200000 250000 ACS Estimate LA Minimum Household Income Data from 2021 1-year ACS, US Census Bureau
N 2 km 0 10 20 30 40 ACS Estimate DC Hispanic Population Data from 2021 1-year ACS, US Census Bureau
N 2 km 0 50000 100000 150000 200000 250000 ACS Estimate DC Minimum Household Income Data from 2021 1-year ACS, US Census Bureau
N 1000 m 25 50 75 ACS Estimate Bronx Hispanic Population Data from 2021 1-year ACS, US Census Bureau
N 1000 m 0 25000 50000 75000 100000 125000 ACS Estimate Bronx Minimum Household Income Data from 2021 1-year ACS, US Census Bureau

Correlations

Created plots to find correlations between percent Hispanic Population and median household income.

## `geom_smooth()` using formula = 'y ~ x'

## `geom_smooth()` using formula = 'y ~ x'

## `geom_smooth()` using formula = 'y ~ x'

## [1] 0.1378796
## [1] -0.5074496
## [1] -0.2770464